CREATE TABLE [dbo].[C_STADIUMS]
(
[stadium] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[city] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[C_STADIUMS] ADD CONSTRAINT [pk_C_Stadiums] PRIMARY KEY CLUSTERED  ([stadium]) ON [PRIMARY]
GO
